home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
alarmsg.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
990b
|
25 lines
/* RCSVER $Id: alarmsg.sql,v 1.4 1999-12-02 16:49:59-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: alarmsg.sql
* Date: 02/19/1999
* memo: Randy Wood
* Description: Create the alarmsg table. This table contains definitions
* of all possible alarm conditions, and associates a
* sound and priority to each.
* Changes:
************************************************************************* */
CREATE TABLE alarmsg
(
alarm_id NUMBER(38), /* Unique ID for this alarm */
priority NUMBER(38), /* Alarm priority */
post_flag NUMBER(38), /* Post this alarm to the file */
sound_class NUMBER(38), /* Sound to associate */
descr VARCHAR2(20), /* Description of alarm */
config_num NUMBER(38)
CONSTRAINT ref1_alarmsg REFERENCES configset(num)
ON DELETE CASCADE,
CONSTRAINT pk_alarmsg PRIMARY KEY (alarm_id, config_num)
);